Data Warehouse Population Platform
نویسندگان
چکیده
The input data for a data warehouse, coming from operational systems, are not immediately ready for loading into data warehouse. Cleaning and integration could be necessary. Moreover, the input data must be transformed and translated into a format more suitable for analytical purposes. This paper presents a generalised platform for population of data warehouses named Data Warehouse Population Platform (DWPP), a set of modules whose aim is to resolve typical aspects arising during the transformation and loading vast amount of data into data warehouse. In Telecom Italia Lab we have realised several Population Systems based on DWPP. The Case Study section describes one of them: Population System for Mobile Network Traffic Data Warehouse.
منابع مشابه
Abnormal Data Formats Identification and Resolution on Data Warehousing Populating Process
Data Warehousing systems are perhaps one of the most valuable assets that organisations possess today. They manage and sustain crucial, strategic information, granting the urging decision support. However, before taking advantage of this magnificent resource, there has to be set a plan to ensure its population. The process of extracting, transforming and loading data into the data warehouse is ...
متن کاملArchitecture of an Open-Sourced, Extensible Data Warehouse Builder: InterBase 6 Data Warehouse Builder (IB-DWB)
We report the development of an open-sourced data warehouse builder, InterBase Data Warehouse Builder (IB-DWB), based on Borland InterBase 6 Open Edition Database Server. InterBase 6 is used for its low maintenance and small footprint. IB-DWB is designed modularly and consists of 5 main components, Data Plug Platform, Discoverer Platform, Multi-Dimensional Cube Builder, and Query Supporter, bou...
متن کاملThe Cooperative Study Between the Hadoop Big Data Platform and the Traditional Data Warehouse
In this paper, based on the application conditions of the existing traditional data warehouse and the future forecast of the Hadoop big data platform, this paper proposes the new framework of the cooperation of Hadoop and traditional data warehouse which focus on the cooperation between the traditional data warehouse and the Hadoop technique to solve the problem that the traditional data wareho...
متن کاملEstudo de Viabilidade de uma Plataforma de Baixo Custo para Data Warehouse
Often corporations need tools that increase the power of decisions in a competitive market. Facing that, several companies does not have resources to buy the commercial systems because of the high costs. This problem can be extended to other segments like government and universities. This work is dedicated to a feasibility study of a low cost platform to data warehouse to supply these customers...
متن کاملUsing Health Information Technology and Data to Improve Chronic Disease Outcomes in Federally Qualified Health Centers in Maryland
Federally Qualified Health Centers provide health care services to underserved communities and vulnerable populations. In Maryland, the burden of chronic disease is high among Federally Qualified Health Center patients. Electronic health records (EHRs) are becoming more widely used, and effective use of EHR data may improve chronic disease outcomes. This article describes the process of develop...
متن کامل